/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 18:14:20
*/


-- ----------------------------
-- Table structure for tb2556
-- ----------------------------
DROP TABLE [dbo].[tb2556]
GO
CREATE TABLE [dbo].[tb2556] (
[EmployeeID] varchar(20) NOT NULL ,
[DivisionID] varchar(20) NULL ,
[BankID] varchar(20) NULL ,
[BankAccountNo] varchar(50) NULL ,
[SoInsuranceNo] varchar(50) NULL ,
[SoInsurBeginDate] datetime NULL ,
[HeInsuranceNo] varchar(50) NULL ,
[ArmyJoinDate] datetime NULL ,
[ArmyEndDate] datetime NULL ,
[ArmyLevel] varchar(50) NULL ,
[Hobby] nvarchar(250) NULL ,
[HospitalID] varchar(20) NULL ,
[Height] varchar(5) NULL ,
[Weight] varchar(5) NULL ,
[BloodGroup] varchar(10) NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb2556
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb2556
-- ----------------------------
ALTER TABLE [dbo].[tb2556] ADD PRIMARY KEY NONCLUSTERED ([EmployeeID])
GO
